################################################
# MySQL
CREATE TABLE SIG_REP_ACTION (ACTION_ID_RAC INTEGER NOT NULL, DESCRIPTION_RAC VARCHAR(50) NOT NULL, PRIMARY KEY (ACTION_ID_RAC));
CREATE TABLE SIG_REP_CATEGORIE_PANNEAU (CATEGORIE_PANNEAU_ID_RCP INTEGER NOT NULL, ABREVIATION_RCP VARCHAR(15) NOT NULL, DESCRIPTION_RCP VARCHAR(50) DEFAULT NULL, PRIMARY KEY (CATEGORIE_PANNEAU_ID_RCP));
CREATE TABLE SIG_REP_ETAT_ACTION (ETAT_ACTION_ID_REA INTEGER NOT NULL, DESCRIPTION_REA VARCHAR(50) NOT NULL, PRIMARY KEY (ETAT_ACTION_ID_REA));
CREATE TABLE SIG_REP_ETAT_ORDRE (ETAT_ORDRE_ID_REO INTEGER NOT NULL, DESCRIPTION_REO VARCHAR(50) NOT NULL, PRIMARY KEY (ETAT_ORDRE_ID_REO));
CREATE TABLE SIG_REP_ETAT_POTEAU (ETAT_POTEAU_ID_REP INTEGER NOT NULL, DESCRIPTION_REP VARCHAR(50) NOT NULL, PRIMARY KEY (ETAT_POTEAU_ID_REP));
CREATE TABLE SIG_REP_ORIENTATION (ORIENTATION_ID_ROR INTEGER NOT NULL, ABREVIATION_ROR VARCHAR(2) NOT NULL, DESCRIPTION_ROR VARCHAR(50) NOT NULL, PRIMARY KEY (ORIENTATION_ID_ROR));
CREATE TABLE SIG_REP_PANNEAU (PANNEAU_ID_RPA INTEGER NOT NULL, CATEGORIE_PANNEAU_ID_RCP INTEGER NOT NULL, CODE_RPA VARCHAR(30) NOT NULL, DESCRIPTION_RPA VARCHAR(255) DEFAULT NULL, PRIMARY KEY (PANNEAU_ID_RPA));
CREATE TABLE SIG_REP_TYPE_ORDRE (TYPE_ORDRE_ID_RTO INTEGER NOT NULL, DESCRIPTION_RTO VARCHAR(50) NOT NULL, PRIMARY KEY (TYPE_ORDRE_ID_RTO));
CREATE TABLE SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP INTEGER NOT NULL, DESCRIPTION_RTP VARCHAR(50) NOT NULL, CODE_RTP VARCHAR(15) NOT NULL, PRIMARY KEY (TYPE_POTEAU_ID_RTP));
CREATE TABLE SIG_POTEAU_PANNEAU (POTEAU_ID_POT INTEGER NOT NULL, PANNEAU_ID_PAN INTEGER NOT NULL, POSITION_POP INTEGER NOT NULL, POTEAU_VERSION_POT INTEGER NOT NULL, PRIMARY KEY (POTEAU_ID_POT,POTEAU_VERSION_POT,PANNEAU_ID_PAN,POSITION_POP));
CREATE TABLE SIG_POTEAU (POTEAU_ID_POT INTEGER NOT NULL, ETAT_POTEAU_ID_REP INTEGER NOT NULL, TYPE_POTEAU_ID_RTP INTEGER NOT NULL, NUMERO_CIVIQUE_POT INTEGER NOT NULL, POTEAU_VERSION_POT INTEGER NOT NULL, TYPE_ORDRE_ID_RTO INTEGER DEFAULT NULL, DATE_CONCEPTION_POT DATETIME DEFAULT NULL, X DOUBLE NOT NULL, Y DOUBLE NOT NULL, NO_DEMANDE_POT VARCHAR(50) DEFAULT NULL, COMMENTAIRES_POT VARCHAR(250) DEFAULT NULL, PRIMARY KEY (POTEAU_ID_POT, POTEAU_VERSION_POT));
CREATE INDEX ETAT_POTEAU_ID_REP_IX ON SIG_POTEAU (ETAT_POTEAU_ID_REP);
CREATE TABLE SIG_PANNEAU (PANNEAU_ID_PAN INTEGER NOT NULL, PANNEAU_ID_RPA INTEGER NOT NULL, ORIENTATION_ID_ROR INTEGER NOT NULL, FLECHE_PAN INTEGER NOT NULL, TOPONYME_PAN VARCHAR(50) DEFAULT NULL, PRIMARY KEY (PANNEAU_ID_PAN), INDEX PANNEAU_ID_RPA_IX (PANNEAU_ID_RPA));
CREATE TABLE SIG_ORDRE_TRAVAIL (ORDRE_TRAVAIL_ID_ORT INTEGER NOT NULL, NUMERO_ORT VARCHAR(10) NOT NULL, USAGER_ID INTEGER DEFAULT NULL, DATE_CONCEPTION_ORT DATETIME NOT NULL, ETAT_ORDRE_ID_REO INTEGER NOT NULL, COMMENTAIRES_ORT VARCHAR(1024) DEFAULT NULL, DATE_EXECUTION_ORT DATETIME DEFAULT NULL, FORMULAIRE_ORT LONGBLOB, DATE_RAPPEL_ORT DATETIME DEFAULT NULL, TYPE_ORDRE_ID_RTO INTEGER NOT NULL, CARTE_CENTRE_X DOUBLE DEFAULT NULL, CARTE_CENTRE_Y DOUBLE DEFAULT NULL, CARTE_ZOOM DOUBLE DEFAULT NULL, CARTE_ANGLE DOUBLE DEFAULT NULL, USAGER_NOM VARCHAR(100), PRIMARY KEY (ORDRE_TRAVAIL_ID_ORT), KEY NUMERO (NUMERO_ORT));
CREATE TABLE SIG_INFO_ORDRE_TRAVAIL (NO_PERMIS_IOT VARCHAR(30) DEFAULT NULL, NOM_ENTREPRENEUR_IOT VARCHAR(50) DEFAULT NULL, DATE_DEBUT_IOT DATETIME DEFAULT NULL, DATE_FIN_IOT DATETIME DEFAULT NULL, RAISON_IOT VARCHAR(50) DEFAULT NULL, ORDRE_TRAVAIL_ID_ORT INTEGER NOT NULL, PRIMARY KEY (ORDRE_TRAVAIL_ID_ORT));
CREATE TABLE SIG_ACTION (ACTION_ID_ACT INTEGER NOT NULL, ACTION_ID_RAC INTEGER NOT NULL, PANNEAU_ID_PAN INTEGER DEFAULT NULL, POTEAU_ID_POT INTEGER DEFAULT NULL, POTEAU_VERSION_POT INTEGER DEFAULT NULL, DATE_EXECUTION_ACT DATETIME DEFAULT NULL, ETAT_ACTION_ID_REA INTEGER NOT NULL, COMMENTAIRES_ACT VARCHAR(255) DEFAULT NULL, ORDRE_TRAVAIL_ID_ORT INTEGER DEFAULT NULL, ACTION_INVERSE_ACT INTEGER NOT NULL, USAGER_ID INTEGER DEFAULT NULL, USAGER_NOM VARCHAR(100), PRIMARY KEY (ACTION_ID_ACT), KEY SIG_IND_01 (PANNEAU_ID_PAN), KEY SIG_IND_ACT_POT (POTEAU_ID_POT,POTEAU_VERSION_POT), KEY SIG_ORDRE_TRAVAIL_ID_ORT_IX (ORDRE_TRAVAIL_ID_ORT));
CREATE TABLE SIG_PERMISSION (USERNAME_PER VARCHAR(50) NOT NULL, PROJECT_ID_PER INTEGER NOT NULL, PERMISSION_PER INTEGER NOT NULL);
CREATE INDEX SIG_PERMISSION ON SIG_PERMISSION (USERNAME_PER, PROJECT_ID_PER);
CREATE TABLE SIG_WORKFLOW (ID_WOF INTEGER NOT NULL, NAME_WOF VARCHAR(50) NOT NULL, DESCRIPTION_WOF VARCHAR(250) NULL, PRIMARY KEY (ID_WOF));
CREATE TABLE SIG_WORKFLOW_STEP (ID_WFS INTEGER NOT NULL, ID_WOF INTEGER NOT NULL, NAME_WFS VARCHAR(50) NOT NULL, DESCRIPTION_WFS VARCHAR(250) NULL, MESSAGE_WFS BLOB, MESSAGE_SUBJECT_WFS VARCHAR(200), UNIQUE KEY STEP_IX (ID_WOF, ID_WFS));
CREATE TABLE SIG_WORKFLOW_TRANSITION (ID_WFT INTEGER NOT NULL, ID_WOF INTEGER NOT NULL, ID_WFS_FROM INTEGER NOT NULL, ID_WFS_TO INTEGER NOT NULL, TYPE_WFT INTEGER NOT NULL, NAME_WFT VARCHAR(50) NOT NULL, DESCRIPTION_WFT VARCHAR(250) NULL, UNIQUE KEY TRANS_IX (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT));
CREATE TABLE SIG_WORKFLOW_CONTACT (ID_WFC INTEGER NOT NULL, ID_WOF INTEGER NOT NULL, ID_WFS INTEGER NOT NULL, NAME_WFC VARCHAR(50) NOT NULL, EMAIL_WFC VARCHAR(50) NOT NULL, UNIQUE KEY CONTACT_IX (ID_WFC, ID_WOF, ID_WFS));
CREATE TABLE SIG_WORKFLOW_STATE (ID_WOF INTEGER NOT NULL, ID_WFS INTEGER NOT NULL, ID_WFC INTEGER NOT NULL, ORDRE_TRAVAIL_ID_ORT INTEGER NOT NULL, STATE_WSS INTEGER NOT NULL, DATE_WSS DATETIME NOT NULL, COMMENTS_WSS VARCHAR(250), UNIQUE KEY CONTACT_IX (ID_WOF, ID_WFC, ID_WFS, ORDRE_TRAVAIL_ID_ORT, STATE_WSS));

################################################
# SQLServer 2000
CREATE TABLE SIG_REP_ACTION (ACTION_ID_RAC INTEGER NOT NULL, DESCRIPTION_RAC VARCHAR(50) NOT NULL, PRIMARY KEY (ACTION_ID_RAC));
CREATE TABLE SIG_REP_CATEGORIE_PANNEAU (CATEGORIE_PANNEAU_ID_RCP INTEGER NOT NULL, ABREVIATION_RCP VARCHAR(15) NOT NULL, DESCRIPTION_RCP VARCHAR(50) DEFAULT NULL, PRIMARY KEY (CATEGORIE_PANNEAU_ID_RCP));
CREATE TABLE SIG_REP_ETAT_ACTION (ETAT_ACTION_ID_REA INTEGER NOT NULL, DESCRIPTION_REA VARCHAR(50) NOT NULL, PRIMARY KEY (ETAT_ACTION_ID_REA));
CREATE TABLE SIG_REP_ETAT_ORDRE (ETAT_ORDRE_ID_REO INTEGER NOT NULL, DESCRIPTION_REO VARCHAR(50) NOT NULL, PRIMARY KEY (ETAT_ORDRE_ID_REO));
CREATE TABLE SIG_REP_ETAT_POTEAU (ETAT_POTEAU_ID_REP INTEGER NOT NULL, DESCRIPTION_REP VARCHAR(50) NOT NULL, PRIMARY KEY (ETAT_POTEAU_ID_REP));
CREATE TABLE SIG_REP_ORIENTATION (ORIENTATION_ID_ROR INTEGER NOT NULL, ABREVIATION_ROR VARCHAR(2) NOT NULL, DESCRIPTION_ROR VARCHAR(50) NOT NULL, PRIMARY KEY (ORIENTATION_ID_ROR));
CREATE TABLE SIG_REP_PANNEAU (PANNEAU_ID_RPA INTEGER NOT NULL, CATEGORIE_PANNEAU_ID_RCP INTEGER NOT NULL, CODE_RPA VARCHAR(30) NOT NULL, DESCRIPTION_RPA VARCHAR(255) DEFAULT NULL, PRIMARY KEY (PANNEAU_ID_RPA));
CREATE TABLE SIG_REP_TYPE_ORDRE (TYPE_ORDRE_ID_RTO INTEGER NOT NULL, DESCRIPTION_RTO VARCHAR(50) NOT NULL, PRIMARY KEY (TYPE_ORDRE_ID_RTO));
CREATE TABLE SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP INTEGER NOT NULL, DESCRIPTION_RTP VARCHAR(50) NOT NULL, CODE_RTP VARCHAR(15) NOT NULL, PRIMARY KEY (TYPE_POTEAU_ID_RTP));
CREATE TABLE SIG_POTEAU_PANNEAU (POTEAU_ID_POT INTEGER NOT NULL, PANNEAU_ID_PAN INTEGER NOT NULL, POSITION_POP INTEGER NOT NULL, POTEAU_VERSION_POT INTEGER NOT NULL, PRIMARY KEY (POTEAU_ID_POT,POTEAU_VERSION_POT,PANNEAU_ID_PAN,POSITION_POP));
CREATE TABLE SIG_POTEAU (POTEAU_ID_POT INTEGER NOT NULL, ETAT_POTEAU_ID_REP INTEGER NOT NULL, TYPE_POTEAU_ID_RTP INTEGER NOT NULL, NUMERO_CIVIQUE_POT INTEGER NOT NULL, POTEAU_VERSION_POT INTEGER NOT NULL, TYPE_ORDRE_ID_RTO INTEGER DEFAULT NULL, DATE_CONCEPTION_POT DATETIME DEFAULT NULL, X DOUBLE PRECISION NOT NULL, Y DOUBLE PRECISION NOT NULL, NO_DEMANDE_POT VARCHAR(50) DEFAULT NULL, COMMENTAIRES_POT VARCHAR(250) DEFAULT NULL, PRIMARY KEY (POTEAU_ID_POT, POTEAU_VERSION_POT));
CREATE INDEX ETAT_POTEAU_ID_REP_IX ON SIG_POTEAU (ETAT_POTEAU_ID_REP);
CREATE TABLE SIG_PANNEAU (PANNEAU_ID_PAN INTEGER NOT NULL, PANNEAU_ID_RPA INTEGER NOT NULL, ORIENTATION_ID_ROR INTEGER NOT NULL, FLECHE_PAN INTEGER NOT NULL, TOPONYME_PAN VARCHAR(50) DEFAULT NULL, PRIMARY KEY (PANNEAU_ID_PAN));
CREATE INDEX PANNEAU_ID_RPA_IX ON SIG_PANNEAU (PANNEAU_ID_RPA);
CREATE TABLE SIG_ORDRE_TRAVAIL (ORDRE_TRAVAIL_ID_ORT INTEGER NOT NULL, NUMERO_ORT VARCHAR(10) NOT NULL, USAGER_ID INTEGER DEFAULT NULL, DATE_CONCEPTION_ORT DATETIME NOT NULL, ETAT_ORDRE_ID_REO INTEGER NOT NULL, COMMENTAIRES_ORT VARCHAR(1024) DEFAULT NULL, DATE_EXECUTION_ORT DATETIME DEFAULT NULL, FORMULAIRE_ORT IMAGE, DATE_RAPPEL_ORT DATETIME DEFAULT NULL, TYPE_ORDRE_ID_RTO INTEGER NOT NULL, CARTE_CENTRE_X DOUBLE PRECISION DEFAULT NULL, CARTE_CENTRE_Y DOUBLE PRECISION DEFAULT NULL, CARTE_ZOOM DOUBLE PRECISION DEFAULT NULL, CARTE_ANGLE DOUBLE PRECISION DEFAULT NULL, USAGER_NOM VARCHAR(100), PRIMARY KEY (ORDRE_TRAVAIL_ID_ORT))
CREATE INDEX NUMERO_ORT_IX ON SIG_ORDRE_TRAVAIL (NUMERO_ORT);
CREATE TABLE SIG_INFO_ORDRE_TRAVAIL (NO_PERMIS_IOT VARCHAR(30) DEFAULT NULL, NOM_ENTREPRENEUR_IOT VARCHAR(50) DEFAULT NULL, DATE_DEBUT_IOT DATETIME DEFAULT NULL, DATE_FIN_IOT DATETIME DEFAULT NULL, RAISON_IOT VARCHAR(50) DEFAULT NULL, ORDRE_TRAVAIL_ID_ORT INTEGER NOT NULL, PRIMARY KEY (ORDRE_TRAVAIL_ID_ORT));
CREATE TABLE SIG_ACTION (ACTION_ID_ACT INTEGER NOT NULL, ACTION_ID_RAC INTEGER NOT NULL, PANNEAU_ID_PAN INTEGER DEFAULT NULL, POTEAU_ID_POT INTEGER DEFAULT NULL, POTEAU_VERSION_POT INTEGER DEFAULT NULL, DATE_EXECUTION_ACT DATETIME DEFAULT NULL, ETAT_ACTION_ID_REA INTEGER NOT NULL, COMMENTAIRES_ACT VARCHAR(255) DEFAULT NULL, ORDRE_TRAVAIL_ID_ORT INTEGER DEFAULT NULL, ACTION_INVERSE_ACT INTEGER NOT NULL, USAGER_ID INTEGER DEFAULT NULL, USAGER_NOM VARCHAR(100), PRIMARY KEY (ACTION_ID_ACT));
CREATE INDEX SIG_IND_01 ON SIG_ACTION (PANNEAU_ID_PAN);
CREATE INDEX SIG_IND_ACT_POT ON SIG_ACTION (POTEAU_ID_POT, POTEAU_VERSION_POT);
CREATE INDEX SIG_ORDRE_TRAVAIL_ID_ORT_IX ON SIG_ACTION (ORDRE_TRAVAIL_ID_ORT);
CREATE TABLE SIG_PERMISSION (USERNAME_PER VARCHAR(50) NOT NULL, PROJECT_ID_PER INTEGER NOT NULL, PERMISSION_PER INTEGER NOT NULL);
CREATE INDEX SIG_PERMISSION ON SIG_PERMISSION (USERNAME_PER, PROJECT_ID_PER);
CREATE TABLE SIG_WORKFLOW (ID_WOF INTEGER NOT NULL, NAME_WOF VARCHAR(50) NOT NULL, DESCRIPTION_WOF VARCHAR(250) NULL, PRIMARY KEY (ID_WOF));
CREATE TABLE SIG_WORKFLOW_STEP (ID_WFS INTEGER NOT NULL, ID_WOF INTEGER NOT NULL, NAME_WFS VARCHAR(50) NOT NULL, DESCRIPTION_WFS VARCHAR(250) NULL, MESSAGE_WFS IMAGE, MESSAGE_SUBJECT_WFS VARCHAR(200));
ALTER TABLE SIG_WORKFLOW_STEP ADD CONSTRAINT STEP_IX UNIQUE(ID_WOF, ID_WFS);
CREATE TABLE SIG_WORKFLOW_TRANSITION (ID_WFT INTEGER NOT NULL, ID_WOF INTEGER NOT NULL, ID_WFS_FROM INTEGER NOT NULL, ID_WFS_TO INTEGER NOT NULL, TYPE_WFT INTEGER NOT NULL, NAME_WFT VARCHAR(50) NOT NULL, DESCRIPTION_WFT VARCHAR(250) NULL);
ALTER TABLE SIG_WORKFLOW_TRANSITION ADD CONSTRAINT TRANS_IX UNIQUE(ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT);
CREATE TABLE SIG_WORKFLOW_CONTACT (ID_WFC INTEGER NOT NULL, ID_WOF INTEGER NOT NULL, ID_WFS INTEGER NOT NULL, NAME_WFC VARCHAR(50) NOT NULL, EMAIL_WFC VARCHAR(50) NOT NULL);
ALTER TABLE SIG_WORKFLOW_CONTACT ADD CONSTRAINT CONTACT_IX UNIQUE(ID_WFC, ID_WOF, ID_WFS);
CREATE TABLE SIG_WORKFLOW_STATE (ID_WOF INTEGER NOT NULL, ID_WFS INTEGER NOT NULL, ID_WFC INTEGER NOT NULL, ORDRE_TRAVAIL_ID_ORT INTEGER NOT NULL, STATE_WSS INTEGER NOT NULL, DATE_WSS DATETIME NOT NULL, COMMENTS_WSS VARCHAR(250));
ALTER TABLE SIG_WORKFLOW_STATE ADD CONSTRAINT STATE_IX UNIQUE(ID_WOF, ID_WFC, ID_WFS, ORDRE_TRAVAIL_ID_ORT, STATE_WSS);


################################################
# Mandatory Data (All databases)
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (0, 'Aucune');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (1, 'Installer');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (2, 'Enlever');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (3, 'Changer');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (4, 'Réparer');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (50, 'Corr.: Aucune');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (51, 'Corr.: Installer');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (52, 'Corr.: Enlever');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (53, 'Corr.: Changer');
INSERT INTO SIG_REP_ACTION (ACTION_ID_RAC, DESCRIPTION_RAC) VALUES (54, 'Corr.: Réparer');

INSERT INTO SIG_REP_ETAT_ACTION (ETAT_ACTION_ID_REA, DESCRIPTION_REA) VALUES (1, 'Réalisé');
INSERT INTO SIG_REP_ETAT_ACTION (ETAT_ACTION_ID_REA, DESCRIPTION_REA) VALUES (2, 'Non réalisé');
INSERT INTO SIG_REP_ETAT_ACTION (ETAT_ACTION_ID_REA, DESCRIPTION_REA) VALUES (3, 'Non réalisable');
INSERT INTO SIG_REP_ETAT_ACTION (ETAT_ACTION_ID_REA, DESCRIPTION_REA) VALUES (4, 'Rien à faire');
INSERT INTO SIG_REP_ETAT_ACTION (ETAT_ACTION_ID_REA, DESCRIPTION_REA) VALUES (5, 'Annulé');

INSERT INTO SIG_REP_ETAT_ORDRE (ETAT_ORDRE_ID_REO, DESCRIPTION_REO) VALUES (1, 'Non transmis');
INSERT INTO SIG_REP_ETAT_ORDRE (ETAT_ORDRE_ID_REO, DESCRIPTION_REO) VALUES (2, 'Approbation');
INSERT INTO SIG_REP_ETAT_ORDRE (ETAT_ORDRE_ID_REO, DESCRIPTION_REO) VALUES (4, 'Transmis');
INSERT INTO SIG_REP_ETAT_ORDRE (ETAT_ORDRE_ID_REO, DESCRIPTION_REO) VALUES (6, 'Exécuté');
INSERT INTO SIG_REP_ETAT_ORDRE (ETAT_ORDRE_ID_REO, DESCRIPTION_REO) VALUES (8, 'Annulé');

INSERT INTO SIG_REP_ETAT_POTEAU (ETAT_POTEAU_ID_REP, DESCRIPTION_REP) VALUES (1, 'Réel');
INSERT INTO SIG_REP_ETAT_POTEAU (ETAT_POTEAU_ID_REP, DESCRIPTION_REP) VALUES (2, 'En conception');
INSERT INTO SIG_REP_ETAT_POTEAU (ETAT_POTEAU_ID_REP, DESCRIPTION_REP) VALUES (3, 'Archive');
INSERT INTO SIG_REP_ETAT_POTEAU (ETAT_POTEAU_ID_REP, DESCRIPTION_REP) VALUES (4, 'Enlevé');
INSERT INTO SIG_REP_ETAT_POTEAU (ETAT_POTEAU_ID_REP, DESCRIPTION_REP) VALUES (5, 'Relevé terrain');

INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (1, 'N', 'Nord');
INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (2, 'NE', 'Nord-Est');
INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (3, 'E', 'Est');
INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (4, 'SE', 'Sud-Est');
INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (5, 'S', 'Sud');
INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (6, 'SO', 'Sud-Ouest');
INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (7, 'O', 'Ouest');
INSERT INTO SIG_REP_ORIENTATION (ORIENTATION_ID_ROR, ABREVIATION_ROR, DESCRIPTION_ROR) VALUES (8, 'NO', 'Nord-Ouest');

INSERT INTO SIG_REP_TYPE_ORDRE (TYPE_ORDRE_ID_RTO, DESCRIPTION_RTO) VALUES (2, 'Général');
INSERT INTO SIG_REP_TYPE_ORDRE (TYPE_ORDRE_ID_RTO, DESCRIPTION_RTO) VALUES (3, 'Saisonnier');

################################################
# Optional data for Demo
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (1, 'Poteau en bois', '4');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (2, 'Poteau en acier', '13');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (3, 'Poteau en barre métallique', '14');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (24, 'Manchon', '15');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (25, 'Tige et base', '1');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (26, 'Tige et manchon', '2');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (27, 'Fût', '3');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (28, 'Fût et feux', '10');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (29, 'Pot. bois/feux', '11');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (30, 'Cable aérien', '5');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (31, 'Base amovible', '6');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (32, 'Console', '7');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (33, 'Pilier', '8');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (34, 'Balise', '12');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (35, 'Autres', '9');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (64, 'Tige et base double', '16');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (65, 'Tige et manchon double', '17');
INSERT INTO SIG_REP_TYPE_POTEAU (TYPE_POTEAU_ID_RTP, DESCRIPTION_RTP, CODE_RTP) VALUES (66, 'Viaduc', '18');

INSERT INTO SIG_REP_CATEGORIE_PANNEAU (CATEGORIE_PANNEAU_ID_RCP, ABREVIATION_RCP, DESCRIPTION_RCP) VALUES (1, 'STATIONNEMENT', 'Stationnement');
INSERT INTO SIG_REP_CATEGORIE_PANNEAU (CATEGORIE_PANNEAU_ID_RCP, ABREVIATION_RCP, DESCRIPTION_RCP) VALUES (23, 'PRESCRIPTION', '');
INSERT INTO SIG_REP_CATEGORIE_PANNEAU (CATEGORIE_PANNEAU_ID_RCP, ABREVIATION_RCP, DESCRIPTION_RCP) VALUES (24, 'DANGER', 'Panneaux de danger');
INSERT INTO SIG_REP_CATEGORIE_PANNEAU (CATEGORIE_PANNEAU_ID_RCP, ABREVIATION_RCP, DESCRIPTION_RCP) VALUES (108, 'TOPONYME', 'Nom de rue');

INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (11, 1, 'AD-TT', 'En tout temps');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1187, 23, 'PB-B-1', 'Passage piétons');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1188, 23, 'PB-B-2', 'Passage piétons');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1705, 23, 'RA-A', 'Arrêt');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1710, 23, 'RA-B', 'Cédez');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1730, 23, 'RC-A', 'Maximum 30');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1735, 23, 'RC-B', 'Maximum 50');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (9208, 23, 'RG-Z', 'Direction des voies');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1768, 23, 'RH-A', 'Obligation virage à gauche');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1770, 23, 'RH-B', 'Obligation virage à droite');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1772, 23, 'RH-D', 'Obligation tout droit');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1774, 23, 'RH-E', 'Obligation tout droit ou virage à droite');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1776, 23, 'RH-F', 'Obligation tout droit ou virage à gauche');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1778, 23, 'RH-G', 'Obligation virage à droite ou virage à gauche');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1780, 23, 'RH-H', 'Interdiction virage en U');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (1980, 23, 'RN-A', 'Sens unique (2 faces)');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (2413, 1, 'SD-TT', 'En tout temps');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (3004, 24, 'WC-D', 'Flèche directionnelle vers la droite');
INSERT INTO SIG_REP_PANNEAU (PANNEAU_ID_RPA, CATEGORIE_PANNEAU_ID_RCP, CODE_RPA, DESCRIPTION_RPA) VALUES (8448, 108, 'NR-U', 'Toponyme');

INSERT INTO SIG_WORKFLOW (ID_WOF, NAME_WOF, DESCRIPTION_WOF) VALUES (1, 'Défaut (1)', 'Processus de travail à 1 niveau d\'approbation');
INSERT INTO SIG_WORKFLOW (ID_WOF, NAME_WOF, DESCRIPTION_WOF) VALUES (2, 'Défaut (2)', 'Processus de travail à 2 niveaux d\'approbation');

INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (0,1,'Bon de travail','Bon de travail à approuver',NULL,NULL);
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (1,1,'Approbation','Approbation par le comité de circulation','Bonjour, Un bon de travail Signal-X vous a été transmis pour approbation. Vous devez accepter ou refuser le bon de travail en affichant la page de confirmation plus bas. Cette étape est nécessaire pour que le processus puisse suivre son cours. @WO{VISUALISER LE BON DE TRAVAIL} @PAGECONF{FORMULAIRE DE CONFIRMATION}','Signal-X: Pour approbation [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (2,1,'Refus','Bon de travail refusé','Bonjour, Un bon de travail a été refusé. @WO{VISUALISER LE BON DE TRAVAIL}','Signal-X: Refus [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (50,1,'Pièces','Pièces','Bonjour, Un bon de travail Signal-X a été émis. La liste des pièces nécessaires vous est transmise. @IL{VISUALISER LA LISTE DES PIÈCES}','Signal-X: Liste des pièces [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (100,1,'Exécution','Exécution des travaux','Bonjour, Un bon de travail Signal-X vous a été transmis pour exécution. Vous pouvez consulter ou imprimer le bon de travail. Lorsque les travaux auront été exécutés, vous devez confirmer le tout en utilisant le lien plus bas. Cette étape est nécessaire pour que le processus puisse suivre son cours. @WO{VISUALISER LE BON DE TRAVAIL} @PAGECONF{FORMULAIRE DE CONFIRMATION}','Signal-X: Pour exécution [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (101,1,'Exécutés','Travaux exécutés','Bonjour, Un bon de travail a été exécuté. @WO{VISUALISER LE BON DE TRAVAIL}','Signal-X: Travaux exécutés [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (102,1,'Non exécutés','Travaux non exécutés','Bonjour, Un bon de travail n\'a pas été exécuté. @WO{VISUALISER LE BON DE TRAVAIL}','Signal-X: Travaux non exécutés [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (0,2,'Bon de travail','Bon de travail à approuver',NULL,NULL);
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (1,2,'Approbation','Approbation par le comité de circulation','Bonjour, Un bon de travail Signal-X vous a été transmis pour approbation. Vous devez accpeter ou refuser le bon de travail en indiquant votre choix plus bas. Cette étape est nécessaire pour que le processus puisse suivre son cours. @WO{VISUALISER LE BON DE TRAVAIL} @ACCEPT{ACCEPTER}	@REFUSE{REFUSER}','Signal-X: Pour approbation [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (2,2,'Refus','Bon de travail refusé','Bonjour, Un bon de travail a été refusé. @WO{VISUALISER LE BON DE TRAVAIL}','Signal-X: Refus [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (3,2,'Approbation','Approbation par un supérieur','Bonjour, Un bon de travail Signal-X vous a été transmis pour approbation. Vous devez accpeter ou refuser le bon de travail en indiquant votre choix plus bas. Cette étape est nécessaire pour que le processus puisse suivre son cours. @WO{VISUALISER LE BON DE TRAVAIL} @ACCEPT{ACCEPTER}	@REFUSE{REFUSER}','Signal-X: Pour approbation [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (4,2,'Refus','Bon de travail refusé','Bonjour, Un bon de travail a été refusé. @WO{VISUALISER LE BON DE TRAVAIL}','Signal-X: Refus [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (100,2,'Exécution','Exécution des travaux','Bonjour, Un bon de travail Signal-X vous a été transmis pour exécution. Vous pouvez consulter ou imprimer le bon de travail. Lorsque les travaux auront été exécutés, vous devez confirmer le tout en utilisant le lien plus bas. Cette étape est nécessaire pour que le processus puisse suivre son cours. @WO{VISUALISER LE BON DE TRAVAIL} @ACCEPT{CONFIRMER QUE LES TRAVAUX ONT ÉTÉ EXÉCUTÉS}','Signal-X: Pour exécution [@WON]');
INSERT INTO SIG_WORKFLOW_STEP (ID_WFS,ID_WOF,NAME_WFS,DESCRIPTION_WFS,MESSAGE_WFS,MESSAGE_SUBJECT_WFS) VALUES (101,2,'Exécutés','Travaux exécutés','Bonjour, Un bon de travail a été exécuté. @WO{VISUALISER LE BON DE TRAVAIL}','Signal-X: Travaux exécutés [@WON]');

INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (0, 1, 0, 1, 0, 'Transmission', 'Transmission du bon de travail pour approbation');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (2, 1, 1, 2, 2, 'Non', 'Bon de travail refusé');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (12, 1, 1, 50, 1, 'Oui', 'Bon de travail approuvé');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (1, 1, 50, 100, 0, 'Commande', 'Commande des pièces');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (11, 1, 100, 101, 1, 'Oui', 'Travaux exécutés');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (13, 1, 100, 102, 2, 'Non', 'Travaux non exécutés');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (3, 2, 0, 1, 0, 'Transmission', 'Transmission du bon de travail pour approbation');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (4, 2, 1, 2, 2, 'Non', 'Bon de travail refusé');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (5, 2, 1, 3, 1, 'Oui', 'Bon de travail approuvé');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (6, 2, 3, 4, 2, 'Non', 'Bon de travail refusé');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (7, 2, 3, 100, 1, 'Oui', 'Bon de travail approuvé');
INSERT INTO SIG_WORKFLOW_TRANSITION (ID_WFT, ID_WOF, ID_WFS_FROM, ID_WFS_TO, TYPE_WFT, NAME_WFT, DESCRIPTION_WFT) VALUES (9, 2, 100, 101, 1, 'Oui', 'Travaux exécutés');


################################################
# Example - Mouse over
<table>
<tr><td align="center" style="width: 118px; background-image: url(http://localhost/signalx/poteau.png); background-repeat: repeat-y;"><img src="http://localhost/signalx/servlet/signalxservlet?action=request_img&code_panneau=%5"></td><td align="center">%5</td></tr>
<tr><td align="center" style="background-image: url(http://localhost/signalx/poteau.png); background-repeat: repeat-y;"><img src="http://localhost/signalx/servlet/signalxservlet?action=request_img&code_panneau=%6"></td><td align="center">%6</td></tr>
<tr><td align="center" style="background-image: url(http://localhost/signalx/poteau.png); background-repeat: repeat-y;"><img src="http://localhost/signalx/servlet/signalxservlet?action=request_img&code_panneau=%7"></td><td align="center">%7</td></tr>
<tr><td align="center" style="background-image: url(http://localhost/signalx/poteau.png); background-repeat: repeat-y;"><img src="http://localhost/signalx/servlet/signalxservlet?action=request_img&code_panneau=%8"></td><td align="center">%8</td></tr>
<tr><td align="center" style="background-image: url(http://localhost/signalx/poteau.png); background-repeat: repeat-y;"><img src="http://localhost/signalx/servlet/signalxservlet?action=request_img&code_panneau=%9"></td><td align="center">%9</td></tr>
<tr><td align="center" style="background-image: url(http://localhost/signalx/poteau.png); background-repeat: repeat-y;"><img src="http://localhost/signalx/servlet/signalxservlet?action=request_img&code_panneau=%10"></td><td align="center">%10</td></tr>
<tr><td align="center" style="background-image: url(http://localhost/signalx/poteau.png); background-repeat: repeat-y;"><img src="http://localhost/signalx/servlet/signalxservlet?action=request_img&code_panneau=%11"></td><td align="center">%11</td></tr>
</table>

ALTER TABLE SIG_REP_PANNEAU MODIFY CODE_RPA VARCHAR(30); // MySQL
ALTER TABLE SIG_ACTION ADD COLUMN USAGER_NOM VARCHAR(100); // MySQL
ALTER TABLE SIG_ORDRE_TRAVAIL ADD COLUMN USAGER_NOM VARCHAR(100); // MySQL

ALTER TABLE SIG_REP_PANNEAU ALTER COLUMN CODE_RPA VARCHAR(30); // SQL Server
ALTER TABLE SIG_ACTION ADD USAGER_NOM VARCHAR(100); // SQL Server
ALTER TABLE SIG_ORDRE_TRAVAIL ADD USAGER_NOM VARCHAR(100); // SQL Server

